Client Maintenance / Client Parameters / Collateral Reserves

Collateral Reserves

The collateral reserve calculations is usually calculated under additional BBC calculations, this amount will be deducted from the individual collaterals or from the total BBC availability of the borrower.

This screen allows you to set up additional collateral types with the associated advance rate, value, and reserve limit.

NavigationClient Maintenance  Client Parameters  Collateral Reserves

Refer to the screenshot:
Collateral Reserves page

Fields and Descriptions

Fields

Descriptions

Collateral

Specifies the collateral name.

Description

Defines the reserve type.

Advance %

Specifies the reserve amount in percentage %.

Value

Specify the value for the reserve.

Reserves

Specifies the total reserve amount.

Based On

Allows the user to select any one of the following to calculate the collateral reserves based on the selected option:

Gross 

Net Eligible

Available

Borrowing Base

Total Available for Advance

Total Collateral

Credit Line

Calculated By

Allows the user to select the collateral name to calculate the collateral reserve.

Reserve %

Specifies the total percentage of reserve amount.

 

To setup a new collateral reserve, perform these steps:

1. Click the Add button button to create a new record.

2. In Collateral field, select the collateral name from the drop-down list

3. Enter the description of the Reserve.

4. Enter the Advance %.

5. Enter the Value of the Reserve.

6. In Based On column, select any one of the option from the drop-down list.

NoteIf user selects Based On option as Credit Line or Total Available for Advance or Total Collateral, then the system displays the Calculated By option in disable mode.

7. In Calculated By column, select any one of the option from the drop-down list.

8. In Reserve % column, enter Collateral Reserve % value.

9. Click the Save button button. The new collateral reserve is setup in the application. You can also add multiple collateral reserves. You can edit, delete, and export the details as required.

Note You can add the either reserve limit (%) or advance rate (%). If both the values are added for a particular collateral type, an error popup appears.

Refer to the screenshot:
Validation - Can't have a value for both Advance and Reserve percentage for the same description

Total AR Reserves = Total AR Available for Advance x %declare on collateral Reserves screen.

Total Inventory Reserve = Total Inventory Available for Advance x %declare on collateral   Reserves screen.

Total Other Collateral Reserve = Total AR Available for Advance x %declare on collateral   Reserves screen.

Total Reserves = Total Collateral value x %declare on collateral Reserves screen.

 

To search the collateral reserve, perform these steps:

1. From the Collateral Type drop-down, choose a collateral type.

2. Click the Search button button to search the record. A Search page appears.  

Refer to the screenshot:
Advanced search popup

3. Populate all the fields as required.

4. Click the Find button button to search the collateral reserve based on the selected options. (Or)

5. Click the Reset button button to reset the fields that you have selected.

 

To export the collateral reserve data, perform these steps: 

1. Click the Export button button to export the collateral reserve data.

Refer to the screenshot:
Collateral reserves

2. Click Save button button to export the collateral reserve date in an excel format. A pop-up message “Do you want to open or save collateral_reserve.xls from cyncsoftware.com?” appears.

3. Click Open if you want to open the extracted collateral reserve data or click Save. The collateral reserve data is extracted in an excel format.

Refer to the screenshot:
save collateral_reserve report - Excel file format